Selecting Import Mode

Select the import mode that define how the data being imported.



Hint: To activate the remaining options, you must enable Primary Key in Adjusting Field Structures and Mapping Fields.



Advanced

Use extended insert statement (Available only for MySQL)
Inserts records using extended insert syntax.

Example:
INSERT INTO `users` VALUES ('1', 'Peter McKindsy', '23'), ('2', 'Johnson Ryne', '56'), ('0', 'Katherine', '23');

Run multiple insert statements (Available only for PostgreSQL and SQL Server)
Checks this option if you want to run multiple insert statements in each execution, which will make the data transfer process faster.

Use empty string as NULL
Imports NULL value if the source data field contains empty string.

Use Foreign Key constraint (Available only for MySQL)
Adds foreign key if there is foreign key relations between tables.

Continue on error
Ignores errors that are encountered during the import process.